﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Dev2DataSet" targetNamespace="http://tempuri.org/Dev2DataSet.xsd" xmlns:mstns="http://tempuri.org/Dev2DataSet.xsd" xmlns="http://tempuri.org/Dev2DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Dev2ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Dev2ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DevDataLibrary.Properties.Settings.GlobalReference.Default.Dev2ConnectionString" Provider="Microsoft.SqlServerCe.Client.3.5" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DTableAdapter" GeneratorDataComponentClassName="DTableAdapter" Name="D" UserDataComponentName="DTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="D" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [D] WHERE (([did] = @p1) AND ([d] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="d" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [D] ([d]) VALUES (@p1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="d" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [did], [d] FROM [D]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [D] SET [d] = @p1 WHERE (([did] = @p2) AND ([d] = @p3))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="d" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="d" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="did" DataSetColumn="did" />
              <Mapping SourceColumn="d" DataSetColumn="d" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="datehasdayofweekrelationshipTableAdapter" GeneratorDataComponentClassName="datehasdayofweekrelationshipTableAdapter" Name="datehasdayofweekrelationship" UserDataComponentName="datehasdayofweekrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="datehasdayofweekrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [datehasdayofweekrelationship] WHERE (([did] = @p1) AND ([dowid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dowid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [datehasdayofweekrelationship] ([did], [dowid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dowid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [did], [dowid] FROM [datehasdayofweekrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [datehasdayofweekrelationship] SET [did] = @p1, [dowid] = @p2 WHERE (([did] = @p3) AND ([dowid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dowid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dowid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="did" DataSetColumn="did" />
              <Mapping SourceColumn="dowid" DataSetColumn="dowid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="datehasshiftrelationshipTableAdapter" GeneratorDataComponentClassName="datehasshiftrelationshipTableAdapter" Name="datehasshiftrelationship" UserDataComponentName="datehasshiftrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="datehasshiftrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [datehasshiftrelationship] WHERE (([did] = @p1) AND ([shid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [datehasshiftrelationship] ([did], [shid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [did], [shid] FROM [datehasshiftrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [datehasshiftrelationship] SET [did] = @p1, [shid] = @p2 WHERE (([did] = @p3) AND ([shid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="did" DataSetColumn="did" />
              <Mapping SourceColumn="shid" DataSetColumn="shid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DayOfWeekTableAdapter" GeneratorDataComponentClassName="DayOfWeekTableAdapter" Name="DayOfWeek" UserDataComponentName="DayOfWeekTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="DayOfWeek" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [DayOfWeek] WHERE (([dowid] = @p1) AND ((@p2 = 1 AND [name] IS NULL) OR ([name] = @p3)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dowid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [DayOfWeek] ([letter], [name]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="letter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [dowid], [letter], [name] FROM [DayOfWeek]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [DayOfWeek] SET [letter] = @p1, [name] = @p2 WHERE (([dowid] = @p3) AND ((@p4 = 1 AND [name] IS NULL) OR ([name] = @p5)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="letter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dowid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="dowid" DataSetColumn="dowid" />
              <Mapping SourceColumn="letter" DataSetColumn="letter" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DepartmentTableAdapter" GeneratorDataComponentClassName="DepartmentTableAdapter" Name="Department" UserDataComponentName="DepartmentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="Department" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Department] WHERE (([deid] = @p1) AND ([name] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Department] ([name]) VALUES (@p1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [deid], [name] FROM [Department]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Department] SET [name] = @p1 WHERE (([deid] = @p2) AND ([name] = @p3))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="deid" DataSetColumn="deid" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="departmenthaslocationrelationshipTableAdapter" GeneratorDataComponentClassName="departmenthaslocationrelationshipTableAdapter" Name="departmenthaslocationrelationship" UserDataComponentName="departmenthaslocationrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="departmenthaslocationrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [departmenthaslocationrelationship] WHERE (([deid] = @p1) AND ([lid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [departmenthaslocationrelationship] ([deid], [lid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [deid], [lid] FROM [departmenthaslocationrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [departmenthaslocationrelationship] SET [deid] = @p1, [lid] = @p2 WHERE (([deid] = @p3) AND ([lid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="deid" DataSetColumn="deid" />
              <Mapping SourceColumn="lid" DataSetColumn="lid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="departmentmanagedbypersonrelationshipTableAdapter" GeneratorDataComponentClassName="departmentmanagedbypersonrelationshipTableAdapter" Name="departmentmanagedbypersonrelationship" UserDataComponentName="departmentmanagedbypersonrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="departmentmanagedbypersonrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [departmentmanagedbypersonrelationship] WHERE (([deid] = @p1) AND ([perid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [departmentmanagedbypersonrelationship] ([deid], [perid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [deid], [perid] FROM [departmentmanagedbypersonrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [departmentmanagedbypersonrelationship] SET [deid] = @p1, [perid] = @p2 WHERE (([deid] = @p3) AND ([perid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="deid" DataSetColumn="deid" />
              <Mapping SourceColumn="perid" DataSetColumn="perid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="departmentneedskillrelationshipTableAdapter" GeneratorDataComponentClassName="departmentneedskillrelationshipTableAdapter" Name="departmentneedskillrelationship" UserDataComponentName="departmentneedskillrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="departmentneedskillrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [departmentneedskillrelationship] WHERE (([deid] = @p1) AND ([sid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [departmentneedskillrelationship] ([deid], [sid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [deid], [sid] FROM [departmentneedskillrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [departmentneedskillrelationship] SET [deid] = @p1, [sid] = @p2 WHERE (([deid] = @p3) AND ([sid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="deid" DataSetColumn="deid" />
              <Mapping SourceColumn="sid" DataSetColumn="sid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="departmentneedstitleTableAdapter" GeneratorDataComponentClassName="departmentneedstitleTableAdapter" Name="departmentneedstitle" UserDataComponentName="departmentneedstitleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="departmentneedstitle" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [departmentneedstitle] ([column_1], [column_2]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="column_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="column_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [column_1], [column_2] FROM [departmentneedstitle]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="column_1" DataSetColumn="column_1" />
              <Mapping SourceColumn="column_2" DataSetColumn="column_2" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="departmentneedtitlerelationshipTableAdapter" GeneratorDataComponentClassName="departmentneedtitlerelationshipTableAdapter" Name="departmentneedtitlerelationship" UserDataComponentName="departmentneedtitlerelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="departmentneedtitlerelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [departmentneedtitlerelationship] WHERE (([deid] = @p1) AND ([tid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [departmentneedtitlerelationship] ([deid], [tid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [deid], [tid] FROM [departmentneedtitlerelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [departmentneedtitlerelationship] SET [deid] = @p1, [tid] = @p2 WHERE (([deid] = @p3) AND ([tid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="deid" DataSetColumn="deid" />
              <Mapping SourceColumn="tid" DataSetColumn="tid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LocationTableAdapter" GeneratorDataComponentClassName="LocationTableAdapter" Name="Location" UserDataComponentName="LocationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="Location" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Location] WHERE (([lid] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Location] ([name]) VALUES (@p1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [lid], [name] FROM [Location]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Location] SET [name] = @p1 WHERE (([lid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="lid" DataSetColumn="lid" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PaygradeTableAdapter" GeneratorDataComponentClassName="PaygradeTableAdapter" Name="Paygrade" UserDataComponentName="PaygradeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="Paygrade" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Paygrade] WHERE (([paid] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Paygrade] ([name], [num]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="num" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [paid], [name], [num] FROM [Paygrade]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Paygrade] SET [name] = @p1, [num] = @p2 WHERE (([paid] = @p3))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="num" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="paid" DataSetColumn="paid" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="num" DataSetColumn="num" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="paygradeneedsskillrelationshipTableAdapter" GeneratorDataComponentClassName="paygradeneedsskillrelationshipTableAdapter" Name="paygradeneedsskillrelationship" UserDataComponentName="paygradeneedsskillrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="paygradeneedsskillrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [paygradeneedsskillrelationship] WHERE (([paid] = @p1) AND ([sid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [paygradeneedsskillrelationship] ([paid], [sid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [paid], [sid] FROM [paygradeneedsskillrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [paygradeneedsskillrelationship] SET [paid] = @p1, [sid] = @p2 WHERE (([paid] = @p3) AND ([sid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="paid" DataSetColumn="paid" />
              <Mapping SourceColumn="sid" DataSetColumn="sid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PermissionTableAdapter" GeneratorDataComponentClassName="PermissionTableAdapter" Name="Permission" UserDataComponentName="PermissionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="Permission" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Permission] WHERE (([peid] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Permission] ([name]) VALUES (@p1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [peid], [name] FROM [Permission]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Permission] SET [name] = @p1 WHERE (([peid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="peid" DataSetColumn="peid" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PersonTableAdapter" GeneratorDataComponentClassName="PersonTableAdapter" Name="Person" UserDataComponentName="PersonTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="Person" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Person] WHERE (([perid] = @p1) AND ([username] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Person] ([firstname], [middlename], [sirname], [approxHours], [username], [password], [suffix], [homephone], [cellphone], [address], [active], [manager]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="firstname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="middlename" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sirname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="approxHours" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="suffix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="homephone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cellphone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="active" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="manager" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [perid], [firstname], [middlename], [sirname], [approxHours], [username], [password], [suffix], [homephone], [cellphone], [address], [active], [manager] FROM [Person]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Person] SET [firstname] = @p1, [middlename] = @p2, [sirname] = @p3, [approxHours] = @p4, [username] = @p5, [password] = @p6, [suffix] = @p7, [homephone] = @p8, [cellphone] = @p9, [address] = @p10, [active] = @p11, [manager] = @p12 WHERE (([perid] = @p13) AND ([username] = @p14))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="firstname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="middlename" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sirname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="approxHours" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="suffix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="homephone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cellphone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="active" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="manager" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="perid" DataSetColumn="perid" />
              <Mapping SourceColumn="firstname" DataSetColumn="firstname" />
              <Mapping SourceColumn="middlename" DataSetColumn="middlename" />
              <Mapping SourceColumn="sirname" DataSetColumn="sirname" />
              <Mapping SourceColumn="approxHours" DataSetColumn="approxHours" />
              <Mapping SourceColumn="username" DataSetColumn="username" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="suffix" DataSetColumn="suffix" />
              <Mapping SourceColumn="homephone" DataSetColumn="homephone" />
              <Mapping SourceColumn="cellphone" DataSetColumn="cellphone" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="active" DataSetColumn="active" />
              <Mapping SourceColumn="manager" DataSetColumn="manager" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="personcalloffdaterelationshipTableAdapter" GeneratorDataComponentClassName="personcalloffdaterelationshipTableAdapter" Name="personcalloffdaterelationship" UserDataComponentName="personcalloffdaterelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="personcalloffdaterelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [personcalloffdaterelationship] WHERE (([perid] = @p1) AND ([did] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [personcalloffdaterelationship] ([perid], [did]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [perid], [did] FROM [personcalloffdaterelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [personcalloffdaterelationship] SET [perid] = @p1, [did] = @p2 WHERE (([perid] = @p3) AND ([did] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="perid" DataSetColumn="perid" />
              <Mapping SourceColumn="did" DataSetColumn="did" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="personhasassaignedshiftrelationshipTableAdapter" GeneratorDataComponentClassName="personhasassaignedshiftrelationshipTableAdapter" Name="personhasassaignedshiftrelationship" UserDataComponentName="personhasassaignedshiftrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="personhasassaignedshiftrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [personhasassaignedshiftrelationship] WHERE (([perid] = @p1) AND ([shid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [personhasassaignedshiftrelationship] ([perid], [shid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [perid], [shid] FROM [personhasassaignedshiftrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [personhasassaignedshiftrelationship] SET [perid] = @p1, [shid] = @p2 WHERE (([perid] = @p3) AND ([shid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="perid" DataSetColumn="perid" />
              <Mapping SourceColumn="shid" DataSetColumn="shid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="personhasdepartmentrelationshipTableAdapter" GeneratorDataComponentClassName="personhasdepartmentrelationshipTableAdapter" Name="personhasdepartmentrelationship" UserDataComponentName="personhasdepartmentrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="personhasdepartmentrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [personhasdepartmentrelationship] WHERE (([perid] = @p1) AND ([deid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [personhasdepartmentrelationship] ([perid], [deid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [perid], [deid] FROM [personhasdepartmentrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [personhasdepartmentrelationship] SET [perid] = @p1, [deid] = @p2 WHERE (([perid] = @p3) AND ([deid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="perid" DataSetColumn="perid" />
              <Mapping SourceColumn="deid" DataSetColumn="deid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="personhaspaygraderelationshipTableAdapter" GeneratorDataComponentClassName="personhaspaygraderelationshipTableAdapter" Name="personhaspaygraderelationship" UserDataComponentName="personhaspaygraderelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="personhaspaygraderelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [personhaspaygraderelationship] WHERE (([perid] = @p1) AND ([paid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [personhaspaygraderelationship] ([perid], [paid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [perid], [paid] FROM [personhaspaygraderelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [personhaspaygraderelationship] SET [perid] = @p1, [paid] = @p2 WHERE (([perid] = @p3) AND ([paid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="perid" DataSetColumn="perid" />
              <Mapping SourceColumn="paid" DataSetColumn="paid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="personhaspreferredshiftrelationshipTableAdapter" GeneratorDataComponentClassName="personhaspreferredshiftrelationshipTableAdapter" Name="personhaspreferredshiftrelationship" UserDataComponentName="personhaspreferredshiftrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="personhaspreferredshiftrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [personhaspreferredshiftrelationship] WHERE (([perid] = @p1) AND ([shid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [personhaspreferredshiftrelationship] ([perid], [shid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [perid], [shid] FROM [personhaspreferredshiftrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [personhaspreferredshiftrelationship] SET [perid] = @p1, [shid] = @p2 WHERE (([perid] = @p3) AND ([shid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="perid" DataSetColumn="perid" />
              <Mapping SourceColumn="shid" DataSetColumn="shid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="personhasskillrelationshipTableAdapter" GeneratorDataComponentClassName="personhasskillrelationshipTableAdapter" Name="personhasskillrelationship" UserDataComponentName="personhasskillrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="personhasskillrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [personhasskillrelationship] WHERE (([perid] = @p1) AND ([sid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [personhasskillrelationship] ([perid], [sid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [perid], [sid] FROM [personhasskillrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [personhasskillrelationship] SET [perid] = @p1, [sid] = @p2 WHERE (([perid] = @p3) AND ([sid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="perid" DataSetColumn="perid" />
              <Mapping SourceColumn="sid" DataSetColumn="sid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="personhassuperiorrelationshipTableAdapter" GeneratorDataComponentClassName="personhassuperiorrelationshipTableAdapter" Name="personhassuperiorrelationship" UserDataComponentName="personhassuperiorrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="personhassuperiorrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [personhassuperiorrelationship] WHERE (([peridA] = @p1) AND ([peridB] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peridA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peridB" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [personhassuperiorrelationship] ([peridA], [peridB]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peridA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peridB" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [peridA], [peridB] FROM [personhassuperiorrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [personhassuperiorrelationship] SET [peridA] = @p1, [peridB] = @p2 WHERE (([peridA] = @p3) AND ([peridB] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peridA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peridB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peridA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peridB" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="peridA" DataSetColumn="peridA" />
              <Mapping SourceColumn="peridB" DataSetColumn="peridB" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="personhastitlerelationshipTableAdapter" GeneratorDataComponentClassName="personhastitlerelationshipTableAdapter" Name="personhastitlerelationship" UserDataComponentName="personhastitlerelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="personhastitlerelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [personhastitlerelationship] WHERE (([perid] = @p1) AND ([tid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [personhastitlerelationship] ([perid], [tid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [perid], [tid] FROM [personhastitlerelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [personhastitlerelationship] SET [perid] = @p1, [tid] = @p2 WHERE (([perid] = @p3) AND ([tid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="perid" DataSetColumn="perid" />
              <Mapping SourceColumn="tid" DataSetColumn="tid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="personpreferrdepartmentrelationshipTableAdapter" GeneratorDataComponentClassName="personpreferrdepartmentrelationshipTableAdapter" Name="personpreferrdepartmentrelationship" UserDataComponentName="personpreferrdepartmentrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="personpreferrdepartmentrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [personpreferrdepartmentrelationship] WHERE (([perid] = @p1) AND ([deid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [personpreferrdepartmentrelationship] ([perid], [deid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [perid], [deid] FROM [personpreferrdepartmentrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [personpreferrdepartmentrelationship] SET [perid] = @p1, [deid] = @p2 WHERE (([perid] = @p3) AND ([deid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="perid" DataSetColumn="perid" />
              <Mapping SourceColumn="deid" DataSetColumn="deid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="personvacationdaterelationshipTableAdapter" GeneratorDataComponentClassName="personvacationdaterelationshipTableAdapter" Name="personvacationdaterelationship" UserDataComponentName="personvacationdaterelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="personvacationdaterelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [personvacationdaterelationship] WHERE (([perid] = @p1) AND ([did] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [personvacationdaterelationship] ([perid], [did]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [perid], [did] FROM [personvacationdaterelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [personvacationdaterelationship] SET [perid] = @p1, [did] = @p2 WHERE (([perid] = @p3) AND ([did] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="perid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="did" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="perid" DataSetColumn="perid" />
              <Mapping SourceColumn="did" DataSetColumn="did" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ShiftTableAdapter" GeneratorDataComponentClassName="ShiftTableAdapter" Name="Shift" UserDataComponentName="ShiftTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="Shift" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Shift] WHERE (([shid] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Shift] ([name], [starttime], [endtime]) VALUES (@p1, @p2, @p3)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="starttime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="endtime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [shid], [name], [starttime], [endtime] FROM [Shift]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Shift] SET [name] = @p1, [starttime] = @p2, [endtime] = @p3 WHERE (([shid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="starttime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="endtime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="shid" DataSetColumn="shid" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="starttime" DataSetColumn="starttime" />
              <Mapping SourceColumn="endtime" DataSetColumn="endtime" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="shifthasdayofweekrelationshipTableAdapter" GeneratorDataComponentClassName="shifthasdayofweekrelationshipTableAdapter" Name="shifthasdayofweekrelationship" UserDataComponentName="shifthasdayofweekrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="shifthasdayofweekrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [shifthasdayofweekrelationship] WHERE (([shid] = @p1) AND ([dowid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dowid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [shifthasdayofweekrelationship] ([shid], [dowid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dowid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [shid], [dowid] FROM [shifthasdayofweekrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [shifthasdayofweekrelationship] SET [shid] = @p1, [dowid] = @p2 WHERE (([shid] = @p3) AND ([dowid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dowid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dowid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="shid" DataSetColumn="shid" />
              <Mapping SourceColumn="dowid" DataSetColumn="dowid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="shiftinsidedepartmentrelationshipTableAdapter" GeneratorDataComponentClassName="shiftinsidedepartmentrelationshipTableAdapter" Name="shiftinsidedepartmentrelationship" UserDataComponentName="shiftinsidedepartmentrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="shiftinsidedepartmentrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [shiftinsidedepartmentrelationship] WHERE (([shid] = @p1) AND ([deid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [shiftinsidedepartmentrelationship] ([shid], [deid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [shid], [deid] FROM [shiftinsidedepartmentrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [shiftinsidedepartmentrelationship] SET [shid] = @p1, [deid] = @p2 WHERE (([shid] = @p3) AND ([deid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="deid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="shid" DataSetColumn="shid" />
              <Mapping SourceColumn="deid" DataSetColumn="deid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="shiftneedsskillrelationshipTableAdapter" GeneratorDataComponentClassName="shiftneedsskillrelationshipTableAdapter" Name="shiftneedsskillrelationship" UserDataComponentName="shiftneedsskillrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="shiftneedsskillrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [shiftneedsskillrelationship] WHERE (([shid] = @p1) AND ([sid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [shiftneedsskillrelationship] ([shid], [sid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [shid], [sid] FROM [shiftneedsskillrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [shiftneedsskillrelationship] SET [shid] = @p1, [sid] = @p2 WHERE (([shid] = @p3) AND ([sid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="shid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="shid" DataSetColumn="shid" />
              <Mapping SourceColumn="sid" DataSetColumn="sid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SkillTableAdapter" GeneratorDataComponentClassName="SkillTableAdapter" Name="Skill" UserDataComponentName="SkillTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="Skill" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Skill] WHERE (([sid] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Skill] ([name]) VALUES (@p1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [sid], [name] FROM [Skill]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Skill] SET [name] = @p1 WHERE (([sid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="sid" DataSetColumn="sid" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TitleTableAdapter" GeneratorDataComponentClassName="TitleTableAdapter" Name="Title" UserDataComponentName="TitleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="Title" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Title] WHERE (([tid] = @p1) AND ((@p2 = 1 AND [name] IS NULL) OR ([name] = @p3)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Title] ([name], [acronym]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="acronym" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [tid], [name], [acronym] FROM [Title]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Title] SET [name] = @p1, [acronym] = @p2 WHERE (([tid] = @p3) AND ((@p4 = 1 AND [name] IS NULL) OR ([name] = @p5)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="acronym" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="tid" DataSetColumn="tid" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="acronym" DataSetColumn="acronym" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="titlehaspermissionrelationshipTableAdapter" GeneratorDataComponentClassName="titlehaspermissionrelationshipTableAdapter" Name="titlehaspermissionrelationship" UserDataComponentName="titlehaspermissionrelationshipTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Dev2ConnectionString (Settings)" DbObjectName="titlehaspermissionrelationship" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [titlehaspermissionrelationship] WHERE (([tid] = @p1) AND ([peid] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [titlehaspermissionrelationship] ([tid], [peid]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [tid], [peid] FROM [titlehaspermissionrelationship]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [titlehaspermissionrelationship] SET [tid] = @p1, [peid] = @p2 WHERE (([tid] = @p3) AND ([peid] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="peid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="tid" DataSetColumn="tid" />
              <Mapping SourceColumn="peid" DataSetColumn="peid" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Dev2DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Dev2DataSet" msprop:Generator_UserDSName="Dev2DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="D" msprop:Generator_TableClassName="DDataTable" msprop:Generator_TableVarName="tableD" msprop:Generator_TablePropName="D" msprop:Generator_RowDeletingName="DRowDeleting" msprop:Generator_UserTableName="D" msprop:Generator_RowChangingName="DRowChanging" msprop:Generator_RowEvHandlerName="DRowChangeEventHandler" msprop:Generator_RowDeletedName="DRowDeleted" msprop:Generator_RowEvArgName="DRowChangeEvent" msprop:Generator_RowChangedName="DRowChanged" msprop:Generator_RowClassName="DRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="did" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columndid" msprop:Generator_ColumnPropNameInRow="did" msprop:Generator_ColumnPropNameInTable="didColumn" msprop:Generator_UserColumnName="did" type="xs:int" />
              <xs:element name="d" msprop:Generator_ColumnVarNameInTable="columnd" msprop:Generator_ColumnPropNameInRow="d" msprop:Generator_ColumnPropNameInTable="dColumn" msprop:Generator_UserColumnName="d">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="datehasdayofweekrelationship" msprop:Generator_TableClassName="datehasdayofweekrelationshipDataTable" msprop:Generator_TableVarName="tabledatehasdayofweekrelationship" msprop:Generator_TablePropName="datehasdayofweekrelationship" msprop:Generator_RowDeletingName="datehasdayofweekrelationshipRowDeleting" msprop:Generator_UserTableName="datehasdayofweekrelationship" msprop:Generator_RowChangingName="datehasdayofweekrelationshipRowChanging" msprop:Generator_RowEvHandlerName="datehasdayofweekrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="datehasdayofweekrelationshipRowDeleted" msprop:Generator_RowEvArgName="datehasdayofweekrelationshipRowChangeEvent" msprop:Generator_RowChangedName="datehasdayofweekrelationshipRowChanged" msprop:Generator_RowClassName="datehasdayofweekrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="did" msprop:Generator_ColumnVarNameInTable="columndid" msprop:Generator_ColumnPropNameInRow="did" msprop:Generator_ColumnPropNameInTable="didColumn" msprop:Generator_UserColumnName="did" type="xs:int" />
              <xs:element name="dowid" msprop:Generator_ColumnVarNameInTable="columndowid" msprop:Generator_ColumnPropNameInRow="dowid" msprop:Generator_ColumnPropNameInTable="dowidColumn" msprop:Generator_UserColumnName="dowid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="datehasshiftrelationship" msprop:Generator_TableClassName="datehasshiftrelationshipDataTable" msprop:Generator_TableVarName="tabledatehasshiftrelationship" msprop:Generator_TablePropName="datehasshiftrelationship" msprop:Generator_RowDeletingName="datehasshiftrelationshipRowDeleting" msprop:Generator_UserTableName="datehasshiftrelationship" msprop:Generator_RowChangingName="datehasshiftrelationshipRowChanging" msprop:Generator_RowEvHandlerName="datehasshiftrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="datehasshiftrelationshipRowDeleted" msprop:Generator_RowEvArgName="datehasshiftrelationshipRowChangeEvent" msprop:Generator_RowChangedName="datehasshiftrelationshipRowChanged" msprop:Generator_RowClassName="datehasshiftrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="did" msprop:Generator_ColumnVarNameInTable="columndid" msprop:Generator_ColumnPropNameInRow="did" msprop:Generator_ColumnPropNameInTable="didColumn" msprop:Generator_UserColumnName="did" type="xs:int" />
              <xs:element name="shid" msprop:Generator_ColumnVarNameInTable="columnshid" msprop:Generator_ColumnPropNameInRow="shid" msprop:Generator_ColumnPropNameInTable="shidColumn" msprop:Generator_UserColumnName="shid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DayOfWeek" msprop:Generator_TableClassName="DayOfWeekDataTable" msprop:Generator_TableVarName="tableDayOfWeek" msprop:Generator_TablePropName="DayOfWeek" msprop:Generator_RowDeletingName="DayOfWeekRowDeleting" msprop:Generator_UserTableName="DayOfWeek" msprop:Generator_RowChangingName="DayOfWeekRowChanging" msprop:Generator_RowEvHandlerName="DayOfWeekRowChangeEventHandler" msprop:Generator_RowDeletedName="DayOfWeekRowDeleted" msprop:Generator_RowEvArgName="DayOfWeekRowChangeEvent" msprop:Generator_RowChangedName="DayOfWeekRowChanged" msprop:Generator_RowClassName="DayOfWeekRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="dowid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columndowid" msprop:Generator_ColumnPropNameInRow="dowid" msprop:Generator_ColumnPropNameInTable="dowidColumn" msprop:Generator_UserColumnName="dowid" type="xs:int" />
              <xs:element name="letter" msprop:Generator_ColumnVarNameInTable="columnletter" msprop:Generator_ColumnPropNameInRow="letter" msprop:Generator_ColumnPropNameInTable="letterColumn" msprop:Generator_UserColumnName="letter" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Department" msprop:Generator_TableClassName="DepartmentDataTable" msprop:Generator_TableVarName="tableDepartment" msprop:Generator_TablePropName="Department" msprop:Generator_RowDeletingName="DepartmentRowDeleting" msprop:Generator_UserTableName="Department" msprop:Generator_RowChangingName="DepartmentRowChanging" msprop:Generator_RowEvHandlerName="DepartmentRowChangeEventHandler" msprop:Generator_RowDeletedName="DepartmentRowDeleted" msprop:Generator_RowEvArgName="DepartmentRowChangeEvent" msprop:Generator_RowChangedName="DepartmentRowChanged" msprop:Generator_RowClassName="DepartmentRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="deid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columndeid" msprop:Generator_ColumnPropNameInRow="deid" msprop:Generator_ColumnPropNameInTable="deidColumn" msprop:Generator_UserColumnName="deid" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="departmenthaslocationrelationship" msprop:Generator_TableClassName="departmenthaslocationrelationshipDataTable" msprop:Generator_TableVarName="tabledepartmenthaslocationrelationship" msprop:Generator_TablePropName="departmenthaslocationrelationship" msprop:Generator_RowDeletingName="departmenthaslocationrelationshipRowDeleting" msprop:Generator_UserTableName="departmenthaslocationrelationship" msprop:Generator_RowChangingName="departmenthaslocationrelationshipRowChanging" msprop:Generator_RowEvHandlerName="departmenthaslocationrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="departmenthaslocationrelationshipRowDeleted" msprop:Generator_RowEvArgName="departmenthaslocationrelationshipRowChangeEvent" msprop:Generator_RowChangedName="departmenthaslocationrelationshipRowChanged" msprop:Generator_RowClassName="departmenthaslocationrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="deid" msprop:Generator_ColumnVarNameInTable="columndeid" msprop:Generator_ColumnPropNameInRow="deid" msprop:Generator_ColumnPropNameInTable="deidColumn" msprop:Generator_UserColumnName="deid" type="xs:int" />
              <xs:element name="lid" msprop:Generator_ColumnVarNameInTable="columnlid" msprop:Generator_ColumnPropNameInRow="lid" msprop:Generator_ColumnPropNameInTable="lidColumn" msprop:Generator_UserColumnName="lid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="departmentmanagedbypersonrelationship" msprop:Generator_TableClassName="departmentmanagedbypersonrelationshipDataTable" msprop:Generator_TableVarName="tabledepartmentmanagedbypersonrelationship" msprop:Generator_TablePropName="departmentmanagedbypersonrelationship" msprop:Generator_RowDeletingName="departmentmanagedbypersonrelationshipRowDeleting" msprop:Generator_UserTableName="departmentmanagedbypersonrelationship" msprop:Generator_RowChangingName="departmentmanagedbypersonrelationshipRowChanging" msprop:Generator_RowEvHandlerName="departmentmanagedbypersonrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="departmentmanagedbypersonrelationshipRowDeleted" msprop:Generator_RowEvArgName="departmentmanagedbypersonrelationshipRowChangeEvent" msprop:Generator_RowChangedName="departmentmanagedbypersonrelationshipRowChanged" msprop:Generator_RowClassName="departmentmanagedbypersonrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="deid" msprop:Generator_ColumnVarNameInTable="columndeid" msprop:Generator_ColumnPropNameInRow="deid" msprop:Generator_ColumnPropNameInTable="deidColumn" msprop:Generator_UserColumnName="deid" type="xs:int" />
              <xs:element name="perid" msprop:Generator_ColumnVarNameInTable="columnperid" msprop:Generator_ColumnPropNameInRow="perid" msprop:Generator_ColumnPropNameInTable="peridColumn" msprop:Generator_UserColumnName="perid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="departmentneedskillrelationship" msprop:Generator_TableClassName="departmentneedskillrelationshipDataTable" msprop:Generator_TableVarName="tabledepartmentneedskillrelationship" msprop:Generator_TablePropName="departmentneedskillrelationship" msprop:Generator_RowDeletingName="departmentneedskillrelationshipRowDeleting" msprop:Generator_UserTableName="departmentneedskillrelationship" msprop:Generator_RowChangingName="departmentneedskillrelationshipRowChanging" msprop:Generator_RowEvHandlerName="departmentneedskillrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="departmentneedskillrelationshipRowDeleted" msprop:Generator_RowEvArgName="departmentneedskillrelationshipRowChangeEvent" msprop:Generator_RowChangedName="departmentneedskillrelationshipRowChanged" msprop:Generator_RowClassName="departmentneedskillrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="deid" msprop:Generator_ColumnVarNameInTable="columndeid" msprop:Generator_ColumnPropNameInRow="deid" msprop:Generator_ColumnPropNameInTable="deidColumn" msprop:Generator_UserColumnName="deid" type="xs:int" />
              <xs:element name="sid" msprop:Generator_ColumnVarNameInTable="columnsid" msprop:Generator_ColumnPropNameInRow="sid" msprop:Generator_ColumnPropNameInTable="sidColumn" msprop:Generator_UserColumnName="sid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="departmentneedstitle" msprop:Generator_TableClassName="departmentneedstitleDataTable" msprop:Generator_TableVarName="tabledepartmentneedstitle" msprop:Generator_TablePropName="departmentneedstitle" msprop:Generator_RowDeletingName="departmentneedstitleRowDeleting" msprop:Generator_UserTableName="departmentneedstitle" msprop:Generator_RowChangingName="departmentneedstitleRowChanging" msprop:Generator_RowEvHandlerName="departmentneedstitleRowChangeEventHandler" msprop:Generator_RowDeletedName="departmentneedstitleRowDeleted" msprop:Generator_RowEvArgName="departmentneedstitleRowChangeEvent" msprop:Generator_RowChangedName="departmentneedstitleRowChanged" msprop:Generator_RowClassName="departmentneedstitleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="column_1" msprop:Generator_ColumnVarNameInTable="columncolumn_1" msprop:Generator_ColumnPropNameInRow="column_1" msprop:Generator_ColumnPropNameInTable="column_1Column" msprop:Generator_UserColumnName="column_1" type="xs:int" />
              <xs:element name="column_2" msprop:Generator_ColumnVarNameInTable="columncolumn_2" msprop:Generator_ColumnPropNameInRow="column_2" msprop:Generator_ColumnPropNameInTable="column_2Column" msprop:Generator_UserColumnName="column_2" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="departmentneedtitlerelationship" msprop:Generator_TableClassName="departmentneedtitlerelationshipDataTable" msprop:Generator_TableVarName="tabledepartmentneedtitlerelationship" msprop:Generator_TablePropName="departmentneedtitlerelationship" msprop:Generator_RowDeletingName="departmentneedtitlerelationshipRowDeleting" msprop:Generator_UserTableName="departmentneedtitlerelationship" msprop:Generator_RowChangingName="departmentneedtitlerelationshipRowChanging" msprop:Generator_RowEvHandlerName="departmentneedtitlerelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="departmentneedtitlerelationshipRowDeleted" msprop:Generator_RowEvArgName="departmentneedtitlerelationshipRowChangeEvent" msprop:Generator_RowChangedName="departmentneedtitlerelationshipRowChanged" msprop:Generator_RowClassName="departmentneedtitlerelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="deid" msprop:Generator_ColumnVarNameInTable="columndeid" msprop:Generator_ColumnPropNameInRow="deid" msprop:Generator_ColumnPropNameInTable="deidColumn" msprop:Generator_UserColumnName="deid" type="xs:int" />
              <xs:element name="tid" msprop:Generator_ColumnVarNameInTable="columntid" msprop:Generator_ColumnPropNameInRow="tid" msprop:Generator_ColumnPropNameInTable="tidColumn" msprop:Generator_UserColumnName="tid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Location" msprop:Generator_TableClassName="LocationDataTable" msprop:Generator_TableVarName="tableLocation" msprop:Generator_TablePropName="Location" msprop:Generator_RowDeletingName="LocationRowDeleting" msprop:Generator_UserTableName="Location" msprop:Generator_RowChangingName="LocationRowChanging" msprop:Generator_RowEvHandlerName="LocationRowChangeEventHandler" msprop:Generator_RowDeletedName="LocationRowDeleted" msprop:Generator_RowEvArgName="LocationRowChangeEvent" msprop:Generator_RowChangedName="LocationRowChanged" msprop:Generator_RowClassName="LocationRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="lid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnlid" msprop:Generator_ColumnPropNameInRow="lid" msprop:Generator_ColumnPropNameInTable="lidColumn" msprop:Generator_UserColumnName="lid" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Paygrade" msprop:Generator_TableClassName="PaygradeDataTable" msprop:Generator_TableVarName="tablePaygrade" msprop:Generator_TablePropName="Paygrade" msprop:Generator_RowDeletingName="PaygradeRowDeleting" msprop:Generator_UserTableName="Paygrade" msprop:Generator_RowChangingName="PaygradeRowChanging" msprop:Generator_RowEvHandlerName="PaygradeRowChangeEventHandler" msprop:Generator_RowDeletedName="PaygradeRowDeleted" msprop:Generator_RowEvArgName="PaygradeRowChangeEvent" msprop:Generator_RowChangedName="PaygradeRowChanged" msprop:Generator_RowClassName="PaygradeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="paid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnpaid" msprop:Generator_ColumnPropNameInRow="paid" msprop:Generator_ColumnPropNameInTable="paidColumn" msprop:Generator_UserColumnName="paid" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="num" msprop:Generator_ColumnVarNameInTable="columnnum" msprop:Generator_ColumnPropNameInRow="num" msprop:Generator_ColumnPropNameInTable="numColumn" msprop:Generator_UserColumnName="num" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="paygradeneedsskillrelationship" msprop:Generator_TableClassName="paygradeneedsskillrelationshipDataTable" msprop:Generator_TableVarName="tablepaygradeneedsskillrelationship" msprop:Generator_TablePropName="paygradeneedsskillrelationship" msprop:Generator_RowDeletingName="paygradeneedsskillrelationshipRowDeleting" msprop:Generator_UserTableName="paygradeneedsskillrelationship" msprop:Generator_RowChangingName="paygradeneedsskillrelationshipRowChanging" msprop:Generator_RowEvHandlerName="paygradeneedsskillrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="paygradeneedsskillrelationshipRowDeleted" msprop:Generator_RowEvArgName="paygradeneedsskillrelationshipRowChangeEvent" msprop:Generator_RowChangedName="paygradeneedsskillrelationshipRowChanged" msprop:Generator_RowClassName="paygradeneedsskillrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="paid" msprop:Generator_ColumnVarNameInTable="columnpaid" msprop:Generator_ColumnPropNameInRow="paid" msprop:Generator_ColumnPropNameInTable="paidColumn" msprop:Generator_UserColumnName="paid" type="xs:int" />
              <xs:element name="sid" msprop:Generator_ColumnVarNameInTable="columnsid" msprop:Generator_ColumnPropNameInRow="sid" msprop:Generator_ColumnPropNameInTable="sidColumn" msprop:Generator_UserColumnName="sid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Permission" msprop:Generator_TableClassName="PermissionDataTable" msprop:Generator_TableVarName="tablePermission" msprop:Generator_TablePropName="Permission" msprop:Generator_RowDeletingName="PermissionRowDeleting" msprop:Generator_UserTableName="Permission" msprop:Generator_RowChangingName="PermissionRowChanging" msprop:Generator_RowEvHandlerName="PermissionRowChangeEventHandler" msprop:Generator_RowDeletedName="PermissionRowDeleted" msprop:Generator_RowEvArgName="PermissionRowChangeEvent" msprop:Generator_RowChangedName="PermissionRowChanged" msprop:Generator_RowClassName="PermissionRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="peid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnpeid" msprop:Generator_ColumnPropNameInRow="peid" msprop:Generator_ColumnPropNameInTable="peidColumn" msprop:Generator_UserColumnName="peid" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Person" msprop:Generator_TableClassName="PersonDataTable" msprop:Generator_TableVarName="tablePerson" msprop:Generator_TablePropName="Person" msprop:Generator_RowDeletingName="PersonRowDeleting" msprop:Generator_UserTableName="Person" msprop:Generator_RowChangingName="PersonRowChanging" msprop:Generator_RowEvHandlerName="PersonRowChangeEventHandler" msprop:Generator_RowDeletedName="PersonRowDeleted" msprop:Generator_RowEvArgName="PersonRowChangeEvent" msprop:Generator_RowChangedName="PersonRowChanged" msprop:Generator_RowClassName="PersonRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="perid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnperid" msprop:Generator_ColumnPropNameInRow="perid" msprop:Generator_ColumnPropNameInTable="peridColumn" msprop:Generator_UserColumnName="perid" type="xs:int" />
              <xs:element name="firstname" msprop:Generator_ColumnVarNameInTable="columnfirstname" msprop:Generator_ColumnPropNameInRow="firstname" msprop:Generator_ColumnPropNameInTable="firstnameColumn" msprop:Generator_UserColumnName="firstname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="middlename" msprop:Generator_ColumnVarNameInTable="columnmiddlename" msprop:Generator_ColumnPropNameInRow="middlename" msprop:Generator_ColumnPropNameInTable="middlenameColumn" msprop:Generator_UserColumnName="middlename">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sirname" msprop:Generator_ColumnVarNameInTable="columnsirname" msprop:Generator_ColumnPropNameInRow="sirname" msprop:Generator_ColumnPropNameInTable="sirnameColumn" msprop:Generator_UserColumnName="sirname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="approxHours" msprop:Generator_ColumnVarNameInTable="columnapproxHours" msprop:Generator_ColumnPropNameInRow="approxHours" msprop:Generator_ColumnPropNameInTable="approxHoursColumn" msprop:Generator_UserColumnName="approxHours" type="xs:int" />
              <xs:element name="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnPropNameInTable="usernameColumn" msprop:Generator_UserColumnName="username">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="suffix" msprop:Generator_ColumnVarNameInTable="columnsuffix" msprop:Generator_ColumnPropNameInRow="suffix" msprop:Generator_ColumnPropNameInTable="suffixColumn" msprop:Generator_UserColumnName="suffix">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="homephone" msprop:Generator_ColumnVarNameInTable="columnhomephone" msprop:Generator_ColumnPropNameInRow="homephone" msprop:Generator_ColumnPropNameInTable="homephoneColumn" msprop:Generator_UserColumnName="homephone">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cellphone" msprop:Generator_ColumnVarNameInTable="columncellphone" msprop:Generator_ColumnPropNameInRow="cellphone" msprop:Generator_ColumnPropNameInTable="cellphoneColumn" msprop:Generator_UserColumnName="cellphone">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnPropNameInTable="addressColumn" msprop:Generator_UserColumnName="address">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="active" msprop:Generator_ColumnVarNameInTable="columnactive" msprop:Generator_ColumnPropNameInRow="active" msprop:Generator_ColumnPropNameInTable="activeColumn" msprop:Generator_UserColumnName="active" type="xs:short" minOccurs="0" />
              <xs:element name="manager" msprop:Generator_ColumnVarNameInTable="columnmanager" msprop:Generator_ColumnPropNameInRow="manager" msprop:Generator_ColumnPropNameInTable="managerColumn" msprop:Generator_UserColumnName="manager" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="personcalloffdaterelationship" msprop:Generator_TableClassName="personcalloffdaterelationshipDataTable" msprop:Generator_TableVarName="tablepersoncalloffdaterelationship" msprop:Generator_TablePropName="personcalloffdaterelationship" msprop:Generator_RowDeletingName="personcalloffdaterelationshipRowDeleting" msprop:Generator_UserTableName="personcalloffdaterelationship" msprop:Generator_RowChangingName="personcalloffdaterelationshipRowChanging" msprop:Generator_RowEvHandlerName="personcalloffdaterelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="personcalloffdaterelationshipRowDeleted" msprop:Generator_RowEvArgName="personcalloffdaterelationshipRowChangeEvent" msprop:Generator_RowChangedName="personcalloffdaterelationshipRowChanged" msprop:Generator_RowClassName="personcalloffdaterelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="perid" msprop:Generator_ColumnVarNameInTable="columnperid" msprop:Generator_ColumnPropNameInRow="perid" msprop:Generator_ColumnPropNameInTable="peridColumn" msprop:Generator_UserColumnName="perid" type="xs:int" />
              <xs:element name="did" msprop:Generator_ColumnVarNameInTable="columndid" msprop:Generator_ColumnPropNameInRow="did" msprop:Generator_ColumnPropNameInTable="didColumn" msprop:Generator_UserColumnName="did" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="personhasassaignedshiftrelationship" msprop:Generator_TableClassName="personhasassaignedshiftrelationshipDataTable" msprop:Generator_TableVarName="tablepersonhasassaignedshiftrelationship" msprop:Generator_TablePropName="personhasassaignedshiftrelationship" msprop:Generator_RowDeletingName="personhasassaignedshiftrelationshipRowDeleting" msprop:Generator_UserTableName="personhasassaignedshiftrelationship" msprop:Generator_RowChangingName="personhasassaignedshiftrelationshipRowChanging" msprop:Generator_RowEvHandlerName="personhasassaignedshiftrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="personhasassaignedshiftrelationshipRowDeleted" msprop:Generator_RowEvArgName="personhasassaignedshiftrelationshipRowChangeEvent" msprop:Generator_RowChangedName="personhasassaignedshiftrelationshipRowChanged" msprop:Generator_RowClassName="personhasassaignedshiftrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="perid" msprop:Generator_ColumnVarNameInTable="columnperid" msprop:Generator_ColumnPropNameInRow="perid" msprop:Generator_ColumnPropNameInTable="peridColumn" msprop:Generator_UserColumnName="perid" type="xs:int" />
              <xs:element name="shid" msprop:Generator_ColumnVarNameInTable="columnshid" msprop:Generator_ColumnPropNameInRow="shid" msprop:Generator_ColumnPropNameInTable="shidColumn" msprop:Generator_UserColumnName="shid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="personhasdepartmentrelationship" msprop:Generator_TableClassName="personhasdepartmentrelationshipDataTable" msprop:Generator_TableVarName="tablepersonhasdepartmentrelationship" msprop:Generator_TablePropName="personhasdepartmentrelationship" msprop:Generator_RowDeletingName="personhasdepartmentrelationshipRowDeleting" msprop:Generator_UserTableName="personhasdepartmentrelationship" msprop:Generator_RowChangingName="personhasdepartmentrelationshipRowChanging" msprop:Generator_RowEvHandlerName="personhasdepartmentrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="personhasdepartmentrelationshipRowDeleted" msprop:Generator_RowEvArgName="personhasdepartmentrelationshipRowChangeEvent" msprop:Generator_RowChangedName="personhasdepartmentrelationshipRowChanged" msprop:Generator_RowClassName="personhasdepartmentrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="perid" msprop:Generator_ColumnVarNameInTable="columnperid" msprop:Generator_ColumnPropNameInRow="perid" msprop:Generator_ColumnPropNameInTable="peridColumn" msprop:Generator_UserColumnName="perid" type="xs:int" />
              <xs:element name="deid" msprop:Generator_ColumnVarNameInTable="columndeid" msprop:Generator_ColumnPropNameInRow="deid" msprop:Generator_ColumnPropNameInTable="deidColumn" msprop:Generator_UserColumnName="deid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="personhaspaygraderelationship" msprop:Generator_TableClassName="personhaspaygraderelationshipDataTable" msprop:Generator_TableVarName="tablepersonhaspaygraderelationship" msprop:Generator_TablePropName="personhaspaygraderelationship" msprop:Generator_RowDeletingName="personhaspaygraderelationshipRowDeleting" msprop:Generator_UserTableName="personhaspaygraderelationship" msprop:Generator_RowChangingName="personhaspaygraderelationshipRowChanging" msprop:Generator_RowEvHandlerName="personhaspaygraderelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="personhaspaygraderelationshipRowDeleted" msprop:Generator_RowEvArgName="personhaspaygraderelationshipRowChangeEvent" msprop:Generator_RowChangedName="personhaspaygraderelationshipRowChanged" msprop:Generator_RowClassName="personhaspaygraderelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="perid" msprop:Generator_ColumnVarNameInTable="columnperid" msprop:Generator_ColumnPropNameInRow="perid" msprop:Generator_ColumnPropNameInTable="peridColumn" msprop:Generator_UserColumnName="perid" type="xs:int" />
              <xs:element name="paid" msprop:Generator_ColumnVarNameInTable="columnpaid" msprop:Generator_ColumnPropNameInRow="paid" msprop:Generator_ColumnPropNameInTable="paidColumn" msprop:Generator_UserColumnName="paid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="personhaspreferredshiftrelationship" msprop:Generator_TableClassName="personhaspreferredshiftrelationshipDataTable" msprop:Generator_TableVarName="tablepersonhaspreferredshiftrelationship" msprop:Generator_TablePropName="personhaspreferredshiftrelationship" msprop:Generator_RowDeletingName="personhaspreferredshiftrelationshipRowDeleting" msprop:Generator_UserTableName="personhaspreferredshiftrelationship" msprop:Generator_RowChangingName="personhaspreferredshiftrelationshipRowChanging" msprop:Generator_RowEvHandlerName="personhaspreferredshiftrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="personhaspreferredshiftrelationshipRowDeleted" msprop:Generator_RowEvArgName="personhaspreferredshiftrelationshipRowChangeEvent" msprop:Generator_RowChangedName="personhaspreferredshiftrelationshipRowChanged" msprop:Generator_RowClassName="personhaspreferredshiftrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="perid" msprop:Generator_ColumnVarNameInTable="columnperid" msprop:Generator_ColumnPropNameInRow="perid" msprop:Generator_ColumnPropNameInTable="peridColumn" msprop:Generator_UserColumnName="perid" type="xs:int" />
              <xs:element name="shid" msprop:Generator_ColumnVarNameInTable="columnshid" msprop:Generator_ColumnPropNameInRow="shid" msprop:Generator_ColumnPropNameInTable="shidColumn" msprop:Generator_UserColumnName="shid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="personhasskillrelationship" msprop:Generator_TableClassName="personhasskillrelationshipDataTable" msprop:Generator_TableVarName="tablepersonhasskillrelationship" msprop:Generator_TablePropName="personhasskillrelationship" msprop:Generator_RowDeletingName="personhasskillrelationshipRowDeleting" msprop:Generator_UserTableName="personhasskillrelationship" msprop:Generator_RowChangingName="personhasskillrelationshipRowChanging" msprop:Generator_RowEvHandlerName="personhasskillrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="personhasskillrelationshipRowDeleted" msprop:Generator_RowEvArgName="personhasskillrelationshipRowChangeEvent" msprop:Generator_RowChangedName="personhasskillrelationshipRowChanged" msprop:Generator_RowClassName="personhasskillrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="perid" msprop:Generator_ColumnVarNameInTable="columnperid" msprop:Generator_ColumnPropNameInRow="perid" msprop:Generator_ColumnPropNameInTable="peridColumn" msprop:Generator_UserColumnName="perid" type="xs:int" />
              <xs:element name="sid" msprop:Generator_ColumnVarNameInTable="columnsid" msprop:Generator_ColumnPropNameInRow="sid" msprop:Generator_ColumnPropNameInTable="sidColumn" msprop:Generator_UserColumnName="sid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="personhassuperiorrelationship" msprop:Generator_TableClassName="personhassuperiorrelationshipDataTable" msprop:Generator_TableVarName="tablepersonhassuperiorrelationship" msprop:Generator_TablePropName="personhassuperiorrelationship" msprop:Generator_RowDeletingName="personhassuperiorrelationshipRowDeleting" msprop:Generator_UserTableName="personhassuperiorrelationship" msprop:Generator_RowChangingName="personhassuperiorrelationshipRowChanging" msprop:Generator_RowEvHandlerName="personhassuperiorrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="personhassuperiorrelationshipRowDeleted" msprop:Generator_RowEvArgName="personhassuperiorrelationshipRowChangeEvent" msprop:Generator_RowChangedName="personhassuperiorrelationshipRowChanged" msprop:Generator_RowClassName="personhassuperiorrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="peridA" msprop:Generator_ColumnVarNameInTable="columnperidA" msprop:Generator_ColumnPropNameInRow="peridA" msprop:Generator_ColumnPropNameInTable="peridAColumn" msprop:Generator_UserColumnName="peridA" type="xs:int" />
              <xs:element name="peridB" msprop:Generator_ColumnVarNameInTable="columnperidB" msprop:Generator_ColumnPropNameInRow="peridB" msprop:Generator_ColumnPropNameInTable="peridBColumn" msprop:Generator_UserColumnName="peridB" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="personhastitlerelationship" msprop:Generator_TableClassName="personhastitlerelationshipDataTable" msprop:Generator_TableVarName="tablepersonhastitlerelationship" msprop:Generator_TablePropName="personhastitlerelationship" msprop:Generator_RowDeletingName="personhastitlerelationshipRowDeleting" msprop:Generator_UserTableName="personhastitlerelationship" msprop:Generator_RowChangingName="personhastitlerelationshipRowChanging" msprop:Generator_RowEvHandlerName="personhastitlerelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="personhastitlerelationshipRowDeleted" msprop:Generator_RowEvArgName="personhastitlerelationshipRowChangeEvent" msprop:Generator_RowChangedName="personhastitlerelationshipRowChanged" msprop:Generator_RowClassName="personhastitlerelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="perid" msprop:Generator_ColumnVarNameInTable="columnperid" msprop:Generator_ColumnPropNameInRow="perid" msprop:Generator_ColumnPropNameInTable="peridColumn" msprop:Generator_UserColumnName="perid" type="xs:int" />
              <xs:element name="tid" msprop:Generator_ColumnVarNameInTable="columntid" msprop:Generator_ColumnPropNameInRow="tid" msprop:Generator_ColumnPropNameInTable="tidColumn" msprop:Generator_UserColumnName="tid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="personpreferrdepartmentrelationship" msprop:Generator_TableClassName="personpreferrdepartmentrelationshipDataTable" msprop:Generator_TableVarName="tablepersonpreferrdepartmentrelationship" msprop:Generator_TablePropName="personpreferrdepartmentrelationship" msprop:Generator_RowDeletingName="personpreferrdepartmentrelationshipRowDeleting" msprop:Generator_UserTableName="personpreferrdepartmentrelationship" msprop:Generator_RowChangingName="personpreferrdepartmentrelationshipRowChanging" msprop:Generator_RowEvHandlerName="personpreferrdepartmentrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="personpreferrdepartmentrelationshipRowDeleted" msprop:Generator_RowEvArgName="personpreferrdepartmentrelationshipRowChangeEvent" msprop:Generator_RowChangedName="personpreferrdepartmentrelationshipRowChanged" msprop:Generator_RowClassName="personpreferrdepartmentrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="perid" msprop:Generator_ColumnVarNameInTable="columnperid" msprop:Generator_ColumnPropNameInRow="perid" msprop:Generator_ColumnPropNameInTable="peridColumn" msprop:Generator_UserColumnName="perid" type="xs:int" />
              <xs:element name="deid" msprop:Generator_ColumnVarNameInTable="columndeid" msprop:Generator_ColumnPropNameInRow="deid" msprop:Generator_ColumnPropNameInTable="deidColumn" msprop:Generator_UserColumnName="deid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="personvacationdaterelationship" msprop:Generator_TableClassName="personvacationdaterelationshipDataTable" msprop:Generator_TableVarName="tablepersonvacationdaterelationship" msprop:Generator_TablePropName="personvacationdaterelationship" msprop:Generator_RowDeletingName="personvacationdaterelationshipRowDeleting" msprop:Generator_UserTableName="personvacationdaterelationship" msprop:Generator_RowChangingName="personvacationdaterelationshipRowChanging" msprop:Generator_RowEvHandlerName="personvacationdaterelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="personvacationdaterelationshipRowDeleted" msprop:Generator_RowEvArgName="personvacationdaterelationshipRowChangeEvent" msprop:Generator_RowChangedName="personvacationdaterelationshipRowChanged" msprop:Generator_RowClassName="personvacationdaterelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="perid" msprop:Generator_ColumnVarNameInTable="columnperid" msprop:Generator_ColumnPropNameInRow="perid" msprop:Generator_ColumnPropNameInTable="peridColumn" msprop:Generator_UserColumnName="perid" type="xs:int" />
              <xs:element name="did" msprop:Generator_ColumnVarNameInTable="columndid" msprop:Generator_ColumnPropNameInRow="did" msprop:Generator_ColumnPropNameInTable="didColumn" msprop:Generator_UserColumnName="did" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Shift" msprop:Generator_TableClassName="ShiftDataTable" msprop:Generator_TableVarName="tableShift" msprop:Generator_TablePropName="Shift" msprop:Generator_RowDeletingName="ShiftRowDeleting" msprop:Generator_UserTableName="Shift" msprop:Generator_RowChangingName="ShiftRowChanging" msprop:Generator_RowEvHandlerName="ShiftRowChangeEventHandler" msprop:Generator_RowDeletedName="ShiftRowDeleted" msprop:Generator_RowEvArgName="ShiftRowChangeEvent" msprop:Generator_RowChangedName="ShiftRowChanged" msprop:Generator_RowClassName="ShiftRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="shid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnshid" msprop:Generator_ColumnPropNameInRow="shid" msprop:Generator_ColumnPropNameInTable="shidColumn" msprop:Generator_UserColumnName="shid" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="starttime" msprop:Generator_ColumnVarNameInTable="columnstarttime" msprop:Generator_ColumnPropNameInRow="starttime" msprop:Generator_ColumnPropNameInTable="starttimeColumn" msprop:Generator_UserColumnName="starttime" type="xs:dateTime" />
              <xs:element name="endtime" msprop:Generator_ColumnVarNameInTable="columnendtime" msprop:Generator_ColumnPropNameInRow="endtime" msprop:Generator_ColumnPropNameInTable="endtimeColumn" msprop:Generator_UserColumnName="endtime" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="shifthasdayofweekrelationship" msprop:Generator_TableClassName="shifthasdayofweekrelationshipDataTable" msprop:Generator_TableVarName="tableshifthasdayofweekrelationship" msprop:Generator_TablePropName="shifthasdayofweekrelationship" msprop:Generator_RowDeletingName="shifthasdayofweekrelationshipRowDeleting" msprop:Generator_UserTableName="shifthasdayofweekrelationship" msprop:Generator_RowChangingName="shifthasdayofweekrelationshipRowChanging" msprop:Generator_RowEvHandlerName="shifthasdayofweekrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="shifthasdayofweekrelationshipRowDeleted" msprop:Generator_RowEvArgName="shifthasdayofweekrelationshipRowChangeEvent" msprop:Generator_RowChangedName="shifthasdayofweekrelationshipRowChanged" msprop:Generator_RowClassName="shifthasdayofweekrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="shid" msprop:Generator_ColumnVarNameInTable="columnshid" msprop:Generator_ColumnPropNameInRow="shid" msprop:Generator_ColumnPropNameInTable="shidColumn" msprop:Generator_UserColumnName="shid" type="xs:int" />
              <xs:element name="dowid" msprop:Generator_ColumnVarNameInTable="columndowid" msprop:Generator_ColumnPropNameInRow="dowid" msprop:Generator_ColumnPropNameInTable="dowidColumn" msprop:Generator_UserColumnName="dowid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="shiftinsidedepartmentrelationship" msprop:Generator_TableClassName="shiftinsidedepartmentrelationshipDataTable" msprop:Generator_TableVarName="tableshiftinsidedepartmentrelationship" msprop:Generator_TablePropName="shiftinsidedepartmentrelationship" msprop:Generator_RowDeletingName="shiftinsidedepartmentrelationshipRowDeleting" msprop:Generator_UserTableName="shiftinsidedepartmentrelationship" msprop:Generator_RowChangingName="shiftinsidedepartmentrelationshipRowChanging" msprop:Generator_RowEvHandlerName="shiftinsidedepartmentrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="shiftinsidedepartmentrelationshipRowDeleted" msprop:Generator_RowEvArgName="shiftinsidedepartmentrelationshipRowChangeEvent" msprop:Generator_RowChangedName="shiftinsidedepartmentrelationshipRowChanged" msprop:Generator_RowClassName="shiftinsidedepartmentrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="shid" msprop:Generator_ColumnVarNameInTable="columnshid" msprop:Generator_ColumnPropNameInRow="shid" msprop:Generator_ColumnPropNameInTable="shidColumn" msprop:Generator_UserColumnName="shid" type="xs:int" />
              <xs:element name="deid" msprop:Generator_ColumnVarNameInTable="columndeid" msprop:Generator_ColumnPropNameInRow="deid" msprop:Generator_ColumnPropNameInTable="deidColumn" msprop:Generator_UserColumnName="deid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="shiftneedsskillrelationship" msprop:Generator_TableClassName="shiftneedsskillrelationshipDataTable" msprop:Generator_TableVarName="tableshiftneedsskillrelationship" msprop:Generator_TablePropName="shiftneedsskillrelationship" msprop:Generator_RowDeletingName="shiftneedsskillrelationshipRowDeleting" msprop:Generator_UserTableName="shiftneedsskillrelationship" msprop:Generator_RowChangingName="shiftneedsskillrelationshipRowChanging" msprop:Generator_RowEvHandlerName="shiftneedsskillrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="shiftneedsskillrelationshipRowDeleted" msprop:Generator_RowEvArgName="shiftneedsskillrelationshipRowChangeEvent" msprop:Generator_RowChangedName="shiftneedsskillrelationshipRowChanged" msprop:Generator_RowClassName="shiftneedsskillrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="shid" msprop:Generator_ColumnVarNameInTable="columnshid" msprop:Generator_ColumnPropNameInRow="shid" msprop:Generator_ColumnPropNameInTable="shidColumn" msprop:Generator_UserColumnName="shid" type="xs:int" />
              <xs:element name="sid" msprop:Generator_ColumnVarNameInTable="columnsid" msprop:Generator_ColumnPropNameInRow="sid" msprop:Generator_ColumnPropNameInTable="sidColumn" msprop:Generator_UserColumnName="sid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Skill" msprop:Generator_TableClassName="SkillDataTable" msprop:Generator_TableVarName="tableSkill" msprop:Generator_TablePropName="Skill" msprop:Generator_RowDeletingName="SkillRowDeleting" msprop:Generator_UserTableName="Skill" msprop:Generator_RowChangingName="SkillRowChanging" msprop:Generator_RowEvHandlerName="SkillRowChangeEventHandler" msprop:Generator_RowDeletedName="SkillRowDeleted" msprop:Generator_RowEvArgName="SkillRowChangeEvent" msprop:Generator_RowChangedName="SkillRowChanged" msprop:Generator_RowClassName="SkillRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="sid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnsid" msprop:Generator_ColumnPropNameInRow="sid" msprop:Generator_ColumnPropNameInTable="sidColumn" msprop:Generator_UserColumnName="sid" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Title" msprop:Generator_TableClassName="TitleDataTable" msprop:Generator_TableVarName="tableTitle" msprop:Generator_TablePropName="Title" msprop:Generator_RowDeletingName="TitleRowDeleting" msprop:Generator_UserTableName="Title" msprop:Generator_RowChangingName="TitleRowChanging" msprop:Generator_RowEvHandlerName="TitleRowChangeEventHandler" msprop:Generator_RowDeletedName="TitleRowDeleted" msprop:Generator_RowEvArgName="TitleRowChangeEvent" msprop:Generator_RowChangedName="TitleRowChanged" msprop:Generator_RowClassName="TitleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="tid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columntid" msprop:Generator_ColumnPropNameInRow="tid" msprop:Generator_ColumnPropNameInTable="tidColumn" msprop:Generator_UserColumnName="tid" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="acronym" msprop:Generator_ColumnVarNameInTable="columnacronym" msprop:Generator_ColumnPropNameInRow="acronym" msprop:Generator_ColumnPropNameInTable="acronymColumn" msprop:Generator_UserColumnName="acronym" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="titlehaspermissionrelationship" msprop:Generator_TableClassName="titlehaspermissionrelationshipDataTable" msprop:Generator_TableVarName="tabletitlehaspermissionrelationship" msprop:Generator_TablePropName="titlehaspermissionrelationship" msprop:Generator_RowDeletingName="titlehaspermissionrelationshipRowDeleting" msprop:Generator_UserTableName="titlehaspermissionrelationship" msprop:Generator_RowChangingName="titlehaspermissionrelationshipRowChanging" msprop:Generator_RowEvHandlerName="titlehaspermissionrelationshipRowChangeEventHandler" msprop:Generator_RowDeletedName="titlehaspermissionrelationshipRowDeleted" msprop:Generator_RowEvArgName="titlehaspermissionrelationshipRowChangeEvent" msprop:Generator_RowChangedName="titlehaspermissionrelationshipRowChanged" msprop:Generator_RowClassName="titlehaspermissionrelationshipRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="tid" msprop:Generator_ColumnVarNameInTable="columntid" msprop:Generator_ColumnPropNameInRow="tid" msprop:Generator_ColumnPropNameInTable="tidColumn" msprop:Generator_UserColumnName="tid" type="xs:int" />
              <xs:element name="peid" msprop:Generator_ColumnVarNameInTable="columnpeid" msprop:Generator_ColumnPropNameInRow="peid" msprop:Generator_ColumnPropNameInTable="peidColumn" msprop:Generator_UserColumnName="peid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1">
      <xs:selector xpath=".//mstns:D" />
      <xs:field xpath="mstns:d" />
    </xs:unique>
    <xs:unique name="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:D" />
      <xs:field xpath="mstns:did" />
    </xs:unique>
    <xs:unique name="datehasdayofweekrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:datehasdayofweekrelationship" />
      <xs:field xpath="mstns:did" />
      <xs:field xpath="mstns:dowid" />
    </xs:unique>
    <xs:unique name="datehasshiftrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:datehasshiftrelationship" />
      <xs:field xpath="mstns:did" />
      <xs:field xpath="mstns:shid" />
    </xs:unique>
    <xs:unique name="DayOfWeek_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:DayOfWeek" />
      <xs:field xpath="mstns:name" />
    </xs:unique>
    <xs:unique name="DayOfWeek_Constraint2" msdata:ConstraintName="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DayOfWeek" />
      <xs:field xpath="mstns:dowid" />
    </xs:unique>
    <xs:unique name="Department_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:Department" />
      <xs:field xpath="mstns:name" />
    </xs:unique>
    <xs:unique name="Department_Constraint2" msdata:ConstraintName="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Department" />
      <xs:field xpath="mstns:deid" />
    </xs:unique>
    <xs:unique name="departmenthaslocationrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:departmenthaslocationrelationship" />
      <xs:field xpath="mstns:deid" />
      <xs:field xpath="mstns:lid" />
    </xs:unique>
    <xs:unique name="departmentmanagedbypersonrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:departmentmanagedbypersonrelationship" />
      <xs:field xpath="mstns:deid" />
      <xs:field xpath="mstns:perid" />
    </xs:unique>
    <xs:unique name="departmentneedskillrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:departmentneedskillrelationship" />
      <xs:field xpath="mstns:deid" />
      <xs:field xpath="mstns:sid" />
    </xs:unique>
    <xs:unique name="departmentneedtitlerelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:departmentneedtitlerelationship" />
      <xs:field xpath="mstns:deid" />
      <xs:field xpath="mstns:tid" />
    </xs:unique>
    <xs:unique name="Location_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Location" />
      <xs:field xpath="mstns:lid" />
    </xs:unique>
    <xs:unique name="Paygrade_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Paygrade" />
      <xs:field xpath="mstns:paid" />
    </xs:unique>
    <xs:unique name="paygradeneedsskillrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:paygradeneedsskillrelationship" />
      <xs:field xpath="mstns:paid" />
      <xs:field xpath="mstns:sid" />
    </xs:unique>
    <xs:unique name="Permission_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Permission" />
      <xs:field xpath="mstns:peid" />
    </xs:unique>
    <xs:unique name="Person_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:Person" />
      <xs:field xpath="mstns:username" />
    </xs:unique>
    <xs:unique name="Person_Constraint2" msdata:ConstraintName="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Person" />
      <xs:field xpath="mstns:perid" />
    </xs:unique>
    <xs:unique name="personcalloffdaterelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:personcalloffdaterelationship" />
      <xs:field xpath="mstns:perid" />
      <xs:field xpath="mstns:did" />
    </xs:unique>
    <xs:unique name="personhasassaignedshiftrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:personhasassaignedshiftrelationship" />
      <xs:field xpath="mstns:perid" />
      <xs:field xpath="mstns:shid" />
    </xs:unique>
    <xs:unique name="personhasdepartmentrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:personhasdepartmentrelationship" />
      <xs:field xpath="mstns:perid" />
      <xs:field xpath="mstns:deid" />
    </xs:unique>
    <xs:unique name="personhaspaygraderelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:personhaspaygraderelationship" />
      <xs:field xpath="mstns:perid" />
      <xs:field xpath="mstns:paid" />
    </xs:unique>
    <xs:unique name="personhaspreferredshiftrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:personhaspreferredshiftrelationship" />
      <xs:field xpath="mstns:perid" />
      <xs:field xpath="mstns:shid" />
    </xs:unique>
    <xs:unique name="personhasskillrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:personhasskillrelationship" />
      <xs:field xpath="mstns:perid" />
      <xs:field xpath="mstns:sid" />
    </xs:unique>
    <xs:unique name="personhassuperiorrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:personhassuperiorrelationship" />
      <xs:field xpath="mstns:peridA" />
      <xs:field xpath="mstns:peridB" />
    </xs:unique>
    <xs:unique name="personhastitlerelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:personhastitlerelationship" />
      <xs:field xpath="mstns:perid" />
      <xs:field xpath="mstns:tid" />
    </xs:unique>
    <xs:unique name="personpreferrdepartmentrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:personpreferrdepartmentrelationship" />
      <xs:field xpath="mstns:perid" />
      <xs:field xpath="mstns:deid" />
    </xs:unique>
    <xs:unique name="personvacationdaterelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:personvacationdaterelationship" />
      <xs:field xpath="mstns:perid" />
      <xs:field xpath="mstns:did" />
    </xs:unique>
    <xs:unique name="Shift_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Shift" />
      <xs:field xpath="mstns:shid" />
    </xs:unique>
    <xs:unique name="shifthasdayofweekrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:shifthasdayofweekrelationship" />
      <xs:field xpath="mstns:shid" />
      <xs:field xpath="mstns:dowid" />
    </xs:unique>
    <xs:unique name="shiftinsidedepartmentrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:shiftinsidedepartmentrelationship" />
      <xs:field xpath="mstns:shid" />
      <xs:field xpath="mstns:deid" />
    </xs:unique>
    <xs:unique name="shiftneedsskillrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:shiftneedsskillrelationship" />
      <xs:field xpath="mstns:shid" />
      <xs:field xpath="mstns:sid" />
    </xs:unique>
    <xs:unique name="Skill_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Skill" />
      <xs:field xpath="mstns:sid" />
    </xs:unique>
    <xs:unique name="Title_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:Title" />
      <xs:field xpath="mstns:name" />
    </xs:unique>
    <xs:unique name="Title_Constraint2" msdata:ConstraintName="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Title" />
      <xs:field xpath="mstns:tid" />
    </xs:unique>
    <xs:unique name="titlehaspermissionrelationship_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:titlehaspermissionrelationship" />
      <xs:field xpath="mstns:tid" />
      <xs:field xpath="mstns:peid" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK__datehasdayofweekrelationship__00000000000000B7" msdata:parent="D" msdata:child="datehasdayofweekrelationship" msdata:parentkey="did" msdata:childkey="did" msprop:Generator_UserChildTable="datehasdayofweekrelationship" msprop:Generator_ChildPropName="GetdatehasdayofweekrelationshipRows" msprop:Generator_ParentPropName="DRow" msprop:Generator_UserRelationName="FK__datehasdayofweekrelationship__00000000000000B7" msprop:Generator_RelationVarName="relationFK__datehasdayofweekrelationship__00000000000000B7" msprop:Generator_UserParentTable="D" />
      <msdata:Relationship name="FK__datehasdayofweekrelationship__00000000000000BB" msdata:parent="DayOfWeek" msdata:child="datehasdayofweekrelationship" msdata:parentkey="dowid" msdata:childkey="dowid" msprop:Generator_UserChildTable="datehasdayofweekrelationship" msprop:Generator_ChildPropName="GetdatehasdayofweekrelationshipRows" msprop:Generator_ParentPropName="DayOfWeekRow" msprop:Generator_UserRelationName="FK__datehasdayofweekrelationship__00000000000000BB" msprop:Generator_RelationVarName="relationFK__datehasdayofweekrelationship__00000000000000BB" msprop:Generator_UserParentTable="DayOfWeek" />
      <msdata:Relationship name="FK__datehasshiftrelationship__0000000000000238" msdata:parent="D" msdata:child="datehasshiftrelationship" msdata:parentkey="did" msdata:childkey="did" msprop:Generator_UserChildTable="datehasshiftrelationship" msprop:Generator_ChildPropName="GetdatehasshiftrelationshipRows" msprop:Generator_ParentPropName="DRow" msprop:Generator_UserRelationName="FK__datehasshiftrelationship__0000000000000238" msprop:Generator_RelationVarName="relationFK__datehasshiftrelationship__0000000000000238" msprop:Generator_UserParentTable="D" />
      <msdata:Relationship name="FK__datehasshiftrelationship__000000000000023C" msdata:parent="Shift" msdata:child="datehasshiftrelationship" msdata:parentkey="shid" msdata:childkey="shid" msprop:Generator_UserChildTable="datehasshiftrelationship" msprop:Generator_ChildPropName="GetdatehasshiftrelationshipRows" msprop:Generator_ParentPropName="ShiftRow" msprop:Generator_UserRelationName="FK__datehasshiftrelationship__000000000000023C" msprop:Generator_RelationVarName="relationFK__datehasshiftrelationship__000000000000023C" msprop:Generator_UserParentTable="Shift" />
      <msdata:Relationship name="FK__departmenthaslocationrelationship__00000000000000DB" msdata:parent="Department" msdata:child="departmenthaslocationrelationship" msdata:parentkey="deid" msdata:childkey="deid" msprop:Generator_UserChildTable="departmenthaslocationrelationship" msprop:Generator_ChildPropName="GetdepartmenthaslocationrelationshipRows" msprop:Generator_ParentPropName="DepartmentRow" msprop:Generator_UserRelationName="FK__departmenthaslocationrelationship__00000000000000DB" msprop:Generator_RelationVarName="relationFK__departmenthaslocationrelationship__00000000000000DB" msprop:Generator_UserParentTable="Department" />
      <msdata:Relationship name="FK__departmenthaslocationrelationship__00000000000000DF" msdata:parent="Location" msdata:child="departmenthaslocationrelationship" msdata:parentkey="lid" msdata:childkey="lid" msprop:Generator_UserChildTable="departmenthaslocationrelationship" msprop:Generator_ChildPropName="GetdepartmenthaslocationrelationshipRows" msprop:Generator_ParentPropName="LocationRow" msprop:Generator_UserRelationName="FK__departmenthaslocationrelationship__00000000000000DF" msprop:Generator_RelationVarName="relationFK__departmenthaslocationrelationship__00000000000000DF" msprop:Generator_UserParentTable="Location" />
      <msdata:Relationship name="FK__departmentmanagedbypersonrelationship__00000000000000ED" msdata:parent="Department" msdata:child="departmentmanagedbypersonrelationship" msdata:parentkey="deid" msdata:childkey="deid" msprop:Generator_UserChildTable="departmentmanagedbypersonrelationship" msprop:Generator_ChildPropName="GetdepartmentmanagedbypersonrelationshipRows" msprop:Generator_ParentPropName="DepartmentRow" msprop:Generator_UserRelationName="FK__departmentmanagedbypersonrelationship__00000000000000ED" msprop:Generator_RelationVarName="relationFK__departmentmanagedbypersonrelationship__00000000000000ED" msprop:Generator_UserParentTable="Department" />
      <msdata:Relationship name="FK__departmentmanagedbypersonrelationship__00000000000000F1" msdata:parent="Person" msdata:child="departmentmanagedbypersonrelationship" msdata:parentkey="perid" msdata:childkey="perid" msprop:Generator_UserChildTable="departmentmanagedbypersonrelationship" msprop:Generator_ChildPropName="GetdepartmentmanagedbypersonrelationshipRows" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_UserRelationName="FK__departmentmanagedbypersonrelationship__00000000000000F1" msprop:Generator_RelationVarName="relationFK__departmentmanagedbypersonrelationship__00000000000000F1" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__departmentneedskillrelationship__00000000000000FF" msdata:parent="Department" msdata:child="departmentneedskillrelationship" msdata:parentkey="deid" msdata:childkey="deid" msprop:Generator_UserChildTable="departmentneedskillrelationship" msprop:Generator_ChildPropName="GetdepartmentneedskillrelationshipRows" msprop:Generator_ParentPropName="DepartmentRow" msprop:Generator_UserRelationName="FK__departmentneedskillrelationship__00000000000000FF" msprop:Generator_RelationVarName="relationFK__departmentneedskillrelationship__00000000000000FF" msprop:Generator_UserParentTable="Department" />
      <msdata:Relationship name="FK__departmentneedskillrelationship__0000000000000103" msdata:parent="Skill" msdata:child="departmentneedskillrelationship" msdata:parentkey="sid" msdata:childkey="sid" msprop:Generator_UserChildTable="departmentneedskillrelationship" msprop:Generator_ChildPropName="GetdepartmentneedskillrelationshipRows" msprop:Generator_ParentPropName="SkillRow" msprop:Generator_UserRelationName="FK__departmentneedskillrelationship__0000000000000103" msprop:Generator_RelationVarName="relationFK__departmentneedskillrelationship__0000000000000103" msprop:Generator_UserParentTable="Skill" />
      <msdata:Relationship name="FK__departmentneedtitlerelationship__0000000000000116" msdata:parent="Department" msdata:child="departmentneedtitlerelationship" msdata:parentkey="deid" msdata:childkey="deid" msprop:Generator_UserChildTable="departmentneedtitlerelationship" msprop:Generator_ChildPropName="GetdepartmentneedtitlerelationshipRows" msprop:Generator_ParentPropName="DepartmentRow" msprop:Generator_UserRelationName="FK__departmentneedtitlerelationship__0000000000000116" msprop:Generator_RelationVarName="relationFK__departmentneedtitlerelationship__0000000000000116" msprop:Generator_UserParentTable="Department" />
      <msdata:Relationship name="FK__departmentneedtitlerelationship__000000000000011A" msdata:parent="Title" msdata:child="departmentneedtitlerelationship" msdata:parentkey="tid" msdata:childkey="tid" msprop:Generator_UserChildTable="departmentneedtitlerelationship" msprop:Generator_ChildPropName="GetdepartmentneedtitlerelationshipRows" msprop:Generator_ParentPropName="TitleRow" msprop:Generator_UserRelationName="FK__departmentneedtitlerelationship__000000000000011A" msprop:Generator_RelationVarName="relationFK__departmentneedtitlerelationship__000000000000011A" msprop:Generator_UserParentTable="Title" />
      <msdata:Relationship name="FK__paygradeneedsskillrelationship__0000000000000128" msdata:parent="Paygrade" msdata:child="paygradeneedsskillrelationship" msdata:parentkey="paid" msdata:childkey="paid" msprop:Generator_UserChildTable="paygradeneedsskillrelationship" msprop:Generator_ChildPropName="GetpaygradeneedsskillrelationshipRows" msprop:Generator_ParentPropName="PaygradeRow" msprop:Generator_UserRelationName="FK__paygradeneedsskillrelationship__0000000000000128" msprop:Generator_RelationVarName="relationFK__paygradeneedsskillrelationship__0000000000000128" msprop:Generator_UserParentTable="Paygrade" />
      <msdata:Relationship name="FK__paygradeneedsskillrelationship__000000000000012C" msdata:parent="Skill" msdata:child="paygradeneedsskillrelationship" msdata:parentkey="sid" msdata:childkey="sid" msprop:Generator_UserChildTable="paygradeneedsskillrelationship" msprop:Generator_ChildPropName="GetpaygradeneedsskillrelationshipRows" msprop:Generator_ParentPropName="SkillRow" msprop:Generator_UserRelationName="FK__paygradeneedsskillrelationship__000000000000012C" msprop:Generator_RelationVarName="relationFK__paygradeneedsskillrelationship__000000000000012C" msprop:Generator_UserParentTable="Skill" />
      <msdata:Relationship name="FK__personcalloffdaterelationship__000000000000013A" msdata:parent="Person" msdata:child="personcalloffdaterelationship" msdata:parentkey="perid" msdata:childkey="perid" msprop:Generator_UserChildTable="personcalloffdaterelationship" msprop:Generator_ChildPropName="GetpersoncalloffdaterelationshipRows" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_UserRelationName="FK__personcalloffdaterelationship__000000000000013A" msprop:Generator_RelationVarName="relationFK__personcalloffdaterelationship__000000000000013A" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__personcalloffdaterelationship__000000000000013E" msdata:parent="D" msdata:child="personcalloffdaterelationship" msdata:parentkey="did" msdata:childkey="did" msprop:Generator_UserChildTable="personcalloffdaterelationship" msprop:Generator_ChildPropName="GetpersoncalloffdaterelationshipRows" msprop:Generator_ParentPropName="DRow" msprop:Generator_UserRelationName="FK__personcalloffdaterelationship__000000000000013E" msprop:Generator_RelationVarName="relationFK__personcalloffdaterelationship__000000000000013E" msprop:Generator_UserParentTable="D" />
      <msdata:Relationship name="FK__personhasassaignedshiftrelationship__000000000000014C" msdata:parent="Person" msdata:child="personhasassaignedshiftrelationship" msdata:parentkey="perid" msdata:childkey="perid" msprop:Generator_UserChildTable="personhasassaignedshiftrelationship" msprop:Generator_ChildPropName="GetpersonhasassaignedshiftrelationshipRows" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_UserRelationName="FK__personhasassaignedshiftrelationship__000000000000014C" msprop:Generator_RelationVarName="relationFK__personhasassaignedshiftrelationship__000000000000014C" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__personhasassaignedshiftrelationship__0000000000000150" msdata:parent="Shift" msdata:child="personhasassaignedshiftrelationship" msdata:parentkey="shid" msdata:childkey="shid" msprop:Generator_UserChildTable="personhasassaignedshiftrelationship" msprop:Generator_ChildPropName="GetpersonhasassaignedshiftrelationshipRows" msprop:Generator_ParentPropName="ShiftRow" msprop:Generator_UserRelationName="FK__personhasassaignedshiftrelationship__0000000000000150" msprop:Generator_RelationVarName="relationFK__personhasassaignedshiftrelationship__0000000000000150" msprop:Generator_UserParentTable="Shift" />
      <msdata:Relationship name="FK__personhasdepartmentrelationship__000000000000015E" msdata:parent="Person" msdata:child="personhasdepartmentrelationship" msdata:parentkey="perid" msdata:childkey="perid" msprop:Generator_UserChildTable="personhasdepartmentrelationship" msprop:Generator_ChildPropName="GetpersonhasdepartmentrelationshipRows" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_UserRelationName="FK__personhasdepartmentrelationship__000000000000015E" msprop:Generator_RelationVarName="relationFK__personhasdepartmentrelationship__000000000000015E" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__personhasdepartmentrelationship__0000000000000162" msdata:parent="Department" msdata:child="personhasdepartmentrelationship" msdata:parentkey="deid" msdata:childkey="deid" msprop:Generator_UserChildTable="personhasdepartmentrelationship" msprop:Generator_ChildPropName="GetpersonhasdepartmentrelationshipRows" msprop:Generator_ParentPropName="DepartmentRow" msprop:Generator_UserRelationName="FK__personhasdepartmentrelationship__0000000000000162" msprop:Generator_RelationVarName="relationFK__personhasdepartmentrelationship__0000000000000162" msprop:Generator_UserParentTable="Department" />
      <msdata:Relationship name="FK__personhaspaygraderelationship__0000000000000170" msdata:parent="Person" msdata:child="personhaspaygraderelationship" msdata:parentkey="perid" msdata:childkey="perid" msprop:Generator_UserChildTable="personhaspaygraderelationship" msprop:Generator_ChildPropName="GetpersonhaspaygraderelationshipRows" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_UserRelationName="FK__personhaspaygraderelationship__0000000000000170" msprop:Generator_RelationVarName="relationFK__personhaspaygraderelationship__0000000000000170" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__personhaspaygraderelationship__0000000000000174" msdata:parent="Paygrade" msdata:child="personhaspaygraderelationship" msdata:parentkey="paid" msdata:childkey="paid" msprop:Generator_UserChildTable="personhaspaygraderelationship" msprop:Generator_ChildPropName="GetpersonhaspaygraderelationshipRows" msprop:Generator_ParentPropName="PaygradeRow" msprop:Generator_UserRelationName="FK__personhaspaygraderelationship__0000000000000174" msprop:Generator_RelationVarName="relationFK__personhaspaygraderelationship__0000000000000174" msprop:Generator_UserParentTable="Paygrade" />
      <msdata:Relationship name="FK__personhaspreferredshiftrelationship__0000000000000182" msdata:parent="Person" msdata:child="personhaspreferredshiftrelationship" msdata:parentkey="perid" msdata:childkey="perid" msprop:Generator_UserChildTable="personhaspreferredshiftrelationship" msprop:Generator_ChildPropName="GetpersonhaspreferredshiftrelationshipRows" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_UserRelationName="FK__personhaspreferredshiftrelationship__0000000000000182" msprop:Generator_RelationVarName="relationFK__personhaspreferredshiftrelationship__0000000000000182" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__personhaspreferredshiftrelationship__0000000000000186" msdata:parent="Shift" msdata:child="personhaspreferredshiftrelationship" msdata:parentkey="shid" msdata:childkey="shid" msprop:Generator_UserChildTable="personhaspreferredshiftrelationship" msprop:Generator_ChildPropName="GetpersonhaspreferredshiftrelationshipRows" msprop:Generator_ParentPropName="ShiftRow" msprop:Generator_UserRelationName="FK__personhaspreferredshiftrelationship__0000000000000186" msprop:Generator_RelationVarName="relationFK__personhaspreferredshiftrelationship__0000000000000186" msprop:Generator_UserParentTable="Shift" />
      <msdata:Relationship name="FK__personhasskillrelationship__0000000000000194" msdata:parent="Person" msdata:child="personhasskillrelationship" msdata:parentkey="perid" msdata:childkey="perid" msprop:Generator_UserChildTable="personhasskillrelationship" msprop:Generator_ChildPropName="GetpersonhasskillrelationshipRows" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_UserRelationName="FK__personhasskillrelationship__0000000000000194" msprop:Generator_RelationVarName="relationFK__personhasskillrelationship__0000000000000194" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__personhasskillrelationship__0000000000000198" msdata:parent="Skill" msdata:child="personhasskillrelationship" msdata:parentkey="sid" msdata:childkey="sid" msprop:Generator_UserChildTable="personhasskillrelationship" msprop:Generator_ChildPropName="GetpersonhasskillrelationshipRows" msprop:Generator_ParentPropName="SkillRow" msprop:Generator_UserRelationName="FK__personhasskillrelationship__0000000000000198" msprop:Generator_RelationVarName="relationFK__personhasskillrelationship__0000000000000198" msprop:Generator_UserParentTable="Skill" />
      <msdata:Relationship name="FK__personhassuperiorrelationship__00000000000001A6" msdata:parent="Person" msdata:child="personhassuperiorrelationship" msdata:parentkey="perid" msdata:childkey="peridA" msprop:Generator_UserChildTable="personhassuperiorrelationship" msprop:Generator_ChildPropName="GetpersonhassuperiorrelationshipRowsByFK__personhassuperiorrelationship__00000000000001A6" msprop:Generator_ParentPropName="PersonRowByFK__personhassuperiorrelationship__00000000000001A6" msprop:Generator_UserRelationName="FK__personhassuperiorrelationship__00000000000001A6" msprop:Generator_RelationVarName="relationFK__personhassuperiorrelationship__00000000000001A6" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__personhassuperiorrelationship__00000000000001AA" msdata:parent="Person" msdata:child="personhassuperiorrelationship" msdata:parentkey="perid" msdata:childkey="peridB" msprop:Generator_UserChildTable="personhassuperiorrelationship" msprop:Generator_ChildPropName="GetpersonhassuperiorrelationshipRowsByFK__personhassuperiorrelationship__00000000000001AA" msprop:Generator_ParentPropName="PersonRowByFK__personhassuperiorrelationship__00000000000001AA" msprop:Generator_UserRelationName="FK__personhassuperiorrelationship__00000000000001AA" msprop:Generator_RelationVarName="relationFK__personhassuperiorrelationship__00000000000001AA" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__personhastitlerelationship__00000000000001B8" msdata:parent="Person" msdata:child="personhastitlerelationship" msdata:parentkey="perid" msdata:childkey="perid" msprop:Generator_UserChildTable="personhastitlerelationship" msprop:Generator_ChildPropName="GetpersonhastitlerelationshipRows" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_UserRelationName="FK__personhastitlerelationship__00000000000001B8" msprop:Generator_RelationVarName="relationFK__personhastitlerelationship__00000000000001B8" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__personhastitlerelationship__00000000000001BC" msdata:parent="Title" msdata:child="personhastitlerelationship" msdata:parentkey="tid" msdata:childkey="tid" msprop:Generator_UserChildTable="personhastitlerelationship" msprop:Generator_ChildPropName="GetpersonhastitlerelationshipRows" msprop:Generator_ParentPropName="TitleRow" msprop:Generator_UserRelationName="FK__personhastitlerelationship__00000000000001BC" msprop:Generator_RelationVarName="relationFK__personhastitlerelationship__00000000000001BC" msprop:Generator_UserParentTable="Title" />
      <msdata:Relationship name="FK__personpreferrdepartmentrelationship__00000000000001CA" msdata:parent="Person" msdata:child="personpreferrdepartmentrelationship" msdata:parentkey="perid" msdata:childkey="perid" msprop:Generator_UserChildTable="personpreferrdepartmentrelationship" msprop:Generator_ChildPropName="GetpersonpreferrdepartmentrelationshipRows" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_UserRelationName="FK__personpreferrdepartmentrelationship__00000000000001CA" msprop:Generator_RelationVarName="relationFK__personpreferrdepartmentrelationship__00000000000001CA" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__personpreferrdepartmentrelationship__00000000000001CE" msdata:parent="Department" msdata:child="personpreferrdepartmentrelationship" msdata:parentkey="deid" msdata:childkey="deid" msprop:Generator_UserChildTable="personpreferrdepartmentrelationship" msprop:Generator_ChildPropName="GetpersonpreferrdepartmentrelationshipRows" msprop:Generator_ParentPropName="DepartmentRow" msprop:Generator_UserRelationName="FK__personpreferrdepartmentrelationship__00000000000001CE" msprop:Generator_RelationVarName="relationFK__personpreferrdepartmentrelationship__00000000000001CE" msprop:Generator_UserParentTable="Department" />
      <msdata:Relationship name="FK__personvacationdaterelationship__00000000000001DC" msdata:parent="Person" msdata:child="personvacationdaterelationship" msdata:parentkey="perid" msdata:childkey="perid" msprop:Generator_UserChildTable="personvacationdaterelationship" msprop:Generator_ChildPropName="GetpersonvacationdaterelationshipRows" msprop:Generator_ParentPropName="PersonRow" msprop:Generator_UserRelationName="FK__personvacationdaterelationship__00000000000001DC" msprop:Generator_RelationVarName="relationFK__personvacationdaterelationship__00000000000001DC" msprop:Generator_UserParentTable="Person" />
      <msdata:Relationship name="FK__personvacationdaterelationship__00000000000001E0" msdata:parent="D" msdata:child="personvacationdaterelationship" msdata:parentkey="did" msdata:childkey="did" msprop:Generator_UserChildTable="personvacationdaterelationship" msprop:Generator_ChildPropName="GetpersonvacationdaterelationshipRows" msprop:Generator_ParentPropName="DRow" msprop:Generator_UserRelationName="FK__personvacationdaterelationship__00000000000001E0" msprop:Generator_RelationVarName="relationFK__personvacationdaterelationship__00000000000001E0" msprop:Generator_UserParentTable="D" />
      <msdata:Relationship name="FK__shifthasdayofweekrelationship__00000000000001EE" msdata:parent="Shift" msdata:child="shifthasdayofweekrelationship" msdata:parentkey="shid" msdata:childkey="shid" msprop:Generator_UserChildTable="shifthasdayofweekrelationship" msprop:Generator_ChildPropName="GetshifthasdayofweekrelationshipRows" msprop:Generator_ParentPropName="ShiftRow" msprop:Generator_UserRelationName="FK__shifthasdayofweekrelationship__00000000000001EE" msprop:Generator_RelationVarName="relationFK__shifthasdayofweekrelationship__00000000000001EE" msprop:Generator_UserParentTable="Shift" />
      <msdata:Relationship name="FK__shifthasdayofweekrelationship__00000000000001F2" msdata:parent="DayOfWeek" msdata:child="shifthasdayofweekrelationship" msdata:parentkey="dowid" msdata:childkey="dowid" msprop:Generator_UserChildTable="shifthasdayofweekrelationship" msprop:Generator_ChildPropName="GetshifthasdayofweekrelationshipRows" msprop:Generator_ParentPropName="DayOfWeekRow" msprop:Generator_UserRelationName="FK__shifthasdayofweekrelationship__00000000000001F2" msprop:Generator_RelationVarName="relationFK__shifthasdayofweekrelationship__00000000000001F2" msprop:Generator_UserParentTable="DayOfWeek" />
      <msdata:Relationship name="FK__shiftinsidedepartmentrelationship__0000000000000200" msdata:parent="Shift" msdata:child="shiftinsidedepartmentrelationship" msdata:parentkey="shid" msdata:childkey="shid" msprop:Generator_UserChildTable="shiftinsidedepartmentrelationship" msprop:Generator_ChildPropName="GetshiftinsidedepartmentrelationshipRows" msprop:Generator_ParentPropName="ShiftRow" msprop:Generator_UserRelationName="FK__shiftinsidedepartmentrelationship__0000000000000200" msprop:Generator_RelationVarName="relationFK__shiftinsidedepartmentrelationship__0000000000000200" msprop:Generator_UserParentTable="Shift" />
      <msdata:Relationship name="FK__shiftinsidedepartmentrelationship__0000000000000204" msdata:parent="Department" msdata:child="shiftinsidedepartmentrelationship" msdata:parentkey="deid" msdata:childkey="deid" msprop:Generator_UserChildTable="shiftinsidedepartmentrelationship" msprop:Generator_ChildPropName="GetshiftinsidedepartmentrelationshipRows" msprop:Generator_ParentPropName="DepartmentRow" msprop:Generator_UserRelationName="FK__shiftinsidedepartmentrelationship__0000000000000204" msprop:Generator_RelationVarName="relationFK__shiftinsidedepartmentrelationship__0000000000000204" msprop:Generator_UserParentTable="Department" />
      <msdata:Relationship name="FK__shiftneedsskillrelationship__0000000000000212" msdata:parent="Shift" msdata:child="shiftneedsskillrelationship" msdata:parentkey="shid" msdata:childkey="shid" msprop:Generator_UserChildTable="shiftneedsskillrelationship" msprop:Generator_ChildPropName="GetshiftneedsskillrelationshipRows" msprop:Generator_ParentPropName="ShiftRow" msprop:Generator_UserRelationName="FK__shiftneedsskillrelationship__0000000000000212" msprop:Generator_RelationVarName="relationFK__shiftneedsskillrelationship__0000000000000212" msprop:Generator_UserParentTable="Shift" />
      <msdata:Relationship name="FK__shiftneedsskillrelationship__0000000000000216" msdata:parent="Skill" msdata:child="shiftneedsskillrelationship" msdata:parentkey="sid" msdata:childkey="sid" msprop:Generator_UserChildTable="shiftneedsskillrelationship" msprop:Generator_ChildPropName="GetshiftneedsskillrelationshipRows" msprop:Generator_ParentPropName="SkillRow" msprop:Generator_UserRelationName="FK__shiftneedsskillrelationship__0000000000000216" msprop:Generator_RelationVarName="relationFK__shiftneedsskillrelationship__0000000000000216" msprop:Generator_UserParentTable="Skill" />
      <msdata:Relationship name="FK__titlehaspermissionrelationship__0000000000000224" msdata:parent="Title" msdata:child="titlehaspermissionrelationship" msdata:parentkey="tid" msdata:childkey="tid" msprop:Generator_UserChildTable="titlehaspermissionrelationship" msprop:Generator_ChildPropName="GettitlehaspermissionrelationshipRows" msprop:Generator_ParentPropName="TitleRow" msprop:Generator_UserRelationName="FK__titlehaspermissionrelationship__0000000000000224" msprop:Generator_RelationVarName="relationFK__titlehaspermissionrelationship__0000000000000224" msprop:Generator_UserParentTable="Title" />
      <msdata:Relationship name="FK__titlehaspermissionrelationship__0000000000000228" msdata:parent="Permission" msdata:child="titlehaspermissionrelationship" msdata:parentkey="peid" msdata:childkey="peid" msprop:Generator_UserChildTable="titlehaspermissionrelationship" msprop:Generator_ChildPropName="GettitlehaspermissionrelationshipRows" msprop:Generator_ParentPropName="PermissionRow" msprop:Generator_UserRelationName="FK__titlehaspermissionrelationship__0000000000000228" msprop:Generator_RelationVarName="relationFK__titlehaspermissionrelationship__0000000000000228" msprop:Generator_UserParentTable="Permission" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>